<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" /><title>DBOracleTest xref</title>
<link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" />
</head>
<body>
<pre>

<a name="1" href="#1">1</a>   <strong>package</strong> <a href="../../../../org/apache/torque/adapter/package-summary.html">org.apache.torque.adapter</a>;
<a name="2" href="#2">2</a>   
<a name="3" href="#3">3</a>   <em class="comment">/*</em>
<a name="4" href="#4">4</a>   <em class="comment"> * Licensed to the Apache Software Foundation (ASF) under one</em>
<a name="5" href="#5">5</a>   <em class="comment"> * or more contributor license agreements.  See the NOTICE file</em>
<a name="6" href="#6">6</a>   <em class="comment"> * distributed with this work for additional information</em>
<a name="7" href="#7">7</a>   <em class="comment"> * regarding copyright ownership.  The ASF licenses this file</em>
<a name="8" href="#8">8</a>   <em class="comment"> * to you under the Apache License, Version 2.0 (the</em>
<a name="9" href="#9">9</a>   <em class="comment"> * "License"); you may not use this file except in compliance</em>
<a name="10" href="#10">10</a>  <em class="comment"> * with the License.  You may obtain a copy of the License at</em>
<a name="11" href="#11">11</a>  <em class="comment"> *</em>
<a name="12" href="#12">12</a>  <em class="comment"> *   <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em>
<a name="13" href="#13">13</a>  <em class="comment"> *</em>
<a name="14" href="#14">14</a>  <em class="comment"> * Unless required by applicable law or agreed to in writing,</em>
<a name="15" href="#15">15</a>  <em class="comment"> * software distributed under the License is distributed on an</em>
<a name="16" href="#16">16</a>  <em class="comment"> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY</em>
<a name="17" href="#17">17</a>  <em class="comment"> * KIND, either express or implied.  See the License for the</em>
<a name="18" href="#18">18</a>  <em class="comment"> * specific language governing permissions and limitations</em>
<a name="19" href="#19">19</a>  <em class="comment"> * under the License.</em>
<a name="20" href="#20">20</a>  <em class="comment"> */</em>
<a name="21" href="#21">21</a>  
<a name="22" href="#22">22</a>  <strong>import</strong> junit.framework.TestCase;
<a name="23" href="#23">23</a>  
<a name="24" href="#24">24</a>  <strong>import</strong> org.apache.torque.util.Query;
<a name="25" href="#25">25</a>  <strong>import</strong> org.apache.torque.util.UniqueList;
<a name="26" href="#26">26</a>  
<a name="27" href="#27">27</a>  <strong>public</strong> <strong>class</strong> <a href="../../../../org/apache/torque/adapter/DBOracleTest.html">DBOracleTest</a> <strong>extends</strong> TestCase
<a name="28" href="#28">28</a>  {
<a name="29" href="#29">29</a>      <em>/**<em>*</em></em>
<a name="30" href="#30">30</a>  <em>     * Tests whether replacing the select columns in limit/offset</em>
<a name="31" href="#31">31</a>  <em>     * treatment works (double column names must be aliased)</em>
<a name="32" href="#32">32</a>  <em>     */</em>
<a name="33" href="#33">33</a>      <strong>public</strong> <strong>void</strong> testSelectColumnsForLimitOffset()
<a name="34" href="#34">34</a>      {
<a name="35" href="#35">35</a>          Query query = <strong>new</strong> Query();
<a name="36" href="#36">36</a>          UniqueList input = <strong>new</strong> UniqueList();
<a name="37" href="#37">37</a>          input.add(<span class="string">"c1"</span>);
<a name="38" href="#38">38</a>          input.add(<span class="string">"c2"</span>);
<a name="39" href="#39">39</a>          input.add(<span class="string">"c1 a1"</span>);
<a name="40" href="#40">40</a>          input.add(<span class="string">"c1 a2"</span>);
<a name="41" href="#41">41</a>          input.add(<span class="string">"t.c1 a4"</span>);
<a name="42" href="#42">42</a>  
<a name="43" href="#43">43</a>          <em class="comment">// A list with no duplicates must remain unchanged</em>
<a name="44" href="#44">44</a>          query.setSelectClause(<strong>new</strong> UniqueList(input));
<a name="45" href="#45">45</a>          <strong>new</strong> DBOracle().generateLimits(query, 0, 1);
<a name="46" href="#46">46</a>          assertEquals(input, query.getSelectClause());
<a name="47" href="#47">47</a>  
<a name="48" href="#48">48</a>          <em class="comment">// double column names must be aliased</em>
<a name="49" href="#49">49</a>          input.set(1, <span class="string">"t.c1"</span>);
<a name="50" href="#50">50</a>          query.setSelectClause(<strong>new</strong> UniqueList(input));
<a name="51" href="#51">51</a>          <strong>new</strong> DBOracle().generateLimits(query, 0, 1);
<a name="52" href="#52">52</a>          UniqueList expected = <strong>new</strong> UniqueList(input);
<a name="53" href="#53">53</a>          expected.set(1, <span class="string">"t.c1 a0"</span>);
<a name="54" href="#54">54</a>          assertEquals(expected, query.getSelectClause());
<a name="55" href="#55">55</a>  
<a name="56" href="#56">56</a>          <em class="comment">// a column name which is the same as an alias name must be replaced</em>
<a name="57" href="#57">57</a>          input.set(1, <span class="string">"c2"</span>);
<a name="58" href="#58">58</a>          input.set(0, <span class="string">"t.a1"</span>);
<a name="59" href="#59">59</a>          query.setSelectClause(<strong>new</strong> UniqueList(input));
<a name="60" href="#60">60</a>          <strong>new</strong> DBOracle().generateLimits(query, 0, 1);
<a name="61" href="#61">61</a>          expected = <strong>new</strong> UniqueList(input);
<a name="62" href="#62">62</a>          expected.set(0, <span class="string">"t.a1 a0"</span>);
<a name="63" href="#63">63</a>          assertEquals(query.getSelectClause(), expected);
<a name="64" href="#64">64</a>  
<a name="65" href="#65">65</a>          <em class="comment">// triple column names must be made unique</em>
<a name="66" href="#66">66</a>          input.set(1, <span class="string">"t2.a1"</span>);
<a name="67" href="#67">67</a>          query.setSelectClause(<strong>new</strong> UniqueList(input));
<a name="68" href="#68">68</a>          <strong>new</strong> DBOracle().generateLimits(query, 0, 1);
<a name="69" href="#69">69</a>          expected = <strong>new</strong> UniqueList(input);
<a name="70" href="#70">70</a>          expected.set(0, <span class="string">"t.a1 a0"</span>);
<a name="71" href="#71">71</a>          expected.set(1, <span class="string">"t2.a1 a3"</span>);
<a name="72" href="#72">72</a>          assertEquals(expected, query.getSelectClause());
<a name="73" href="#73">73</a>      }
<a name="74" href="#74">74</a>  
<a name="75" href="#75">75</a>  }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

